Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	1696240
Missing cells	6
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	562.2 MiB
Average record size in memory	347.5 B

Variable types

Text	2
Numeric	7
DateTime	1
Categorical	3

Alerts

`game_id` is highly overall correlated with `player_id`	High correlation
`player_club_id` is highly overall correlated with `player_current_club_id`	High correlation
`player_current_club_id` is highly overall correlated with `player_club_id`	High correlation
`player_id` is highly overall correlated with `game_id`	High correlation
`yellow_cards` is highly imbalanced (60.9%)	Imbalance
`red_cards` is highly imbalanced (96.4%)	Imbalance
`appearance_id` has unique values	Unique
`goals` has 1550722 (91.4%) zeros	Zeros
`assists` has 1577536 (93.0%) zeros	Zeros

Reproduction

Analysis started	2025-03-12 19:10:34.392723
Analysis finished	2025-03-12 19:11:10.494902
Duration	36.1 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

appearance_id
Text

Unique

Distinct	1696240
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	114.2 MiB

Length

Max length	15
Median length	14
Mean length	13.575551
Min length	10

Characters and Unicode

Total characters	23027392
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1696240 ?
Unique (%)	100.0%

Sample

1st row	2231978_38004
2nd row	2233748_79232
3rd row	2234413_42792
4th row	2234418_73333
5th row	2234421_122011

Value	Count	Frequency (%)
2231978_38004	1	< 0.1%
2235545_4582	1	< 0.1%
2234421_122011	1	< 0.1%
2234421_146889	1	< 0.1%
2235539_28716	1	< 0.1%
2235539_69445	1	< 0.1%
2235545_19409	1	< 0.1%
2235545_30003	1	< 0.1%
2235545_30667	1	< 0.1%
2235545_34129	1	< 0.1%
Other values (1696230)	1696230	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
2	3089752	13.4%
3	2757615	12.0%
4	2296835	10.0%
1	2189354	9.5%
8	1942858	8.4%
5	1926692	8.4%
9	1811798	7.9%
0	1806407	7.8%
6	1786878	7.8%
7	1722963	7.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	23027392	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	3089752	13.4%
3	2757615	12.0%
4	2296835	10.0%
1	2189354	9.5%
8	1942858	8.4%
5	1926692	8.4%
9	1811798	7.9%
0	1806407	7.8%
6	1786878	7.8%
7	1722963	7.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	23027392	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	3089752	13.4%
3	2757615	12.0%
4	2296835	10.0%
1	2189354	9.5%
8	1942858	8.4%
5	1926692	8.4%
9	1811798	7.9%
0	1806407	7.8%
6	1786878	7.8%
7	1722963	7.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	23027392	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	3089752	13.4%
3	2757615	12.0%
4	2296835	10.0%
1	2189354	9.5%
8	1942858	8.4%
5	1926692	8.4%
9	1811798	7.9%
0	1806407	7.8%
6	1786878	7.8%
7	1722963	7.5%

game_id
Real number (ℝ)

High correlation

Distinct	66489
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3158399.9

Minimum	2211607
Maximum	4570633
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	2211607
5-th percentile	2250206
Q1	2588911
median	3080230
Q3	3615124
95-th percentile	4367902
Maximum	4570633
Range	2359026
Interquartile range (IQR)	1026213

Descriptive statistics

Standard deviation	659964.01
Coefficient of variation (CV)	0.20895518
Kurtosis	-1.079163
Mean	3158399.9
Median Absolute Deviation (MAD)	522868
Skewness	0.33004758
Sum	5.3574042 × 10¹²
Variance	4.355525 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2884392	36	< 0.1%
4098010	35	< 0.1%
4545866	35	< 0.1%
2740103	34	< 0.1%
4041615	34	< 0.1%
4002937	34	< 0.1%
4243699	34	< 0.1%
4243720	34	< 0.1%
4547624	34	< 0.1%
4148218	34	< 0.1%
Other values (66479)	1695896	> 99.9%

Value	Count	Frequency (%)
2211607	27	< 0.1%
2218677	28	< 0.1%
2219794	28	< 0.1%
2219795	28	< 0.1%
2221641	14	< 0.1%
2221747	1	< 0.1%
2221748	1	< 0.1%
2221749	14	< 0.1%
2221751	14	< 0.1%
2221753	14	< 0.1%

Value	Count	Frequency (%)
4570633	27	< 0.1%
4562600	32	< 0.1%
4562599	31	< 0.1%
4562598	32	< 0.1%
4562597	14	< 0.1%
4562596	30	< 0.1%
4562595	17	< 0.1%
4562593	14	< 0.1%
4559306	32	< 0.1%
4559305	29	< 0.1%

player_id
Real number (ℝ)

High correlation

Distinct	25664
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	208378.94

Minimum	10
Maximum	1380876
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	10
5-th percentile	15452
Q1	58252
median	148396
Q3	300168
95-th percentile	603149
Maximum	1380876
Range	1380866
Interquartile range (IQR)	241916

Descriptive statistics

Standard deviation	192896.79
Coefficient of variation (CV)	0.92570193
Kurtosis	2.1678302
Mean	208378.94
Median Absolute Deviation (MAD)	103452
Skewness	1.4389129
Sum	3.534607 × 10¹¹
Variance	3.7209171 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38253	605	< 0.1%
32467	578	< 0.1%
59561	563	< 0.1%
125781	563	< 0.1%
74229	560	< 0.1%
36139	558	< 0.1%
28396	558	< 0.1%
56416	551	< 0.1%
91845	549	< 0.1%
65278	545	< 0.1%
Other values (25654)	1690610	99.7%

Value	Count	Frequency (%)
10	136	< 0.1%
26	152	< 0.1%
65	122	< 0.1%
77	4	< 0.1%
80	12	< 0.1%
109	41	< 0.1%
123	7	< 0.1%
132	77	< 0.1%
215	109	< 0.1%
258	19	< 0.1%

Value	Count	Frequency (%)
1380876	1	< 0.1%
1378362	1	< 0.1%
1358447	1	< 0.1%
1310513	3	< 0.1%
1309326	3	< 0.1%
1306851	8	< 0.1%
1302421	5	< 0.1%
1294052	11	< 0.1%
1294049	5	< 0.1%
1294048	2	< 0.1%

player_club_id
Real number (ℝ)

High correlation

Distinct	1064
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3124.6588

Minimum	1
Maximum	116786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	1
5-th percentile	27
Q1	289
median	826
Q3	2441
95-th percentile	16239
Maximum	116786
Range	116785
Interquartile range (IQR)	2152

Descriptive statistics

Standard deviation	8249.8986
Coefficient of variation (CV)	2.6402558
Kurtosis	37.534466
Mean	3124.6588
Median Absolute Deviation (MAD)	626
Skewness	5.5673787
Sum	5.3001712 × 10⁹
Variance	68060826
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
418	10257	0.6%
131	10166	0.6%
368	9983	0.6%
506	9644	0.6%
985	9631	0.6%
281	9571	0.6%
631	9554	0.6%
31	9443	0.6%
371	9358	0.6%
27	9324	0.5%
Other values (1054)	1599309	94.3%

Value	Count	Frequency (%)
1	3	< 0.1%
2	13	< 0.1%
3	4896	0.3%
4	1501	0.1%
5	8964	0.5%
6	467	< 0.1%
9	4	< 0.1%
10	1087	0.1%
11	9290	0.5%
12	9022	0.5%

Value	Count	Frequency (%)
116786	2	< 0.1%
110302	361	< 0.1%
101634	1	< 0.1%
101362	3	< 0.1%
99200	2	< 0.1%
91328	3	< 0.1%
87883	1	< 0.1%
86209	285	< 0.1%
85465	327	< 0.1%
83678	445	< 0.1%

player_current_club_id
Real number (ℝ)

High correlation

Distinct	438
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3979.587

Minimum	-1
Maximum	110302
Zeros	0
Zeros (%)	0.0%
Negative	6
Negative (%)	< 0.1%
Memory size	12.9 MiB

Quantile statistics

Minimum	-1
5-th percentile	29
Q1	331
median	903
Q3	2696
95-th percentile	19771
Maximum	110302
Range	110303
Interquartile range (IQR)	2365

Descriptive statistics

Standard deviation	10806.832
Coefficient of variation (CV)	2.7155662
Kurtosis	30.513925
Mean	3979.587
Median Absolute Deviation (MAD)	713
Skewness	5.1000201
Sum	6.7503347 × 10⁹
Variance	1.1678762 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36	11702	0.7%
683	10785	0.6%
1091	10266	0.6%
150	10255	0.6%
46	10109	0.6%
141	10108	0.6%
13	9981	0.6%
2381	9958	0.6%
368	9628	0.6%
589	9498	0.6%
Other values (428)	1593950	94.0%

Value	Count	Frequency (%)
-1	6	< 0.1%
3	4765	0.3%
4	987	0.1%
5	8638	0.5%
6	618	< 0.1%
10	1190	0.1%
11	7593	0.4%
12	8008	0.5%
13	9981	0.6%
15	7461	0.4%

Value	Count	Frequency (%)
110302	2320	0.1%
86209	729	< 0.1%
85465	1892	0.1%
83678	769	< 0.1%
75231	824	< 0.1%
71985	1222	0.1%
68608	1977	0.1%
63007	2555	0.2%
61825	2392	0.1%
60949	4824	0.3%

date
Date

Distinct	3717
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

Minimum	2012-07-03 00:00:00
Maximum	2025-03-10 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

player_name
Text

Distinct	25119
Distinct (%)	1.5%
Missing	6
Missing (%)	< 0.1%
Memory size	126.2 MiB

Length

Max length	32
Median length	29
Mean length	13.473428
Min length	2

Characters and Unicode

Total characters	22854086
Distinct characters	121
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2111 ?
Unique (%)	0.1%

Sample

1st row	Aurélien Joachim
2nd row	Ruslan Abyshov
3rd row	Sander Puri
4th row	Vegar Hedenstad
5th row	Markus Henriksen

Value	Count	Frequency (%)
de	14398	0.4%
van	14237	0.4%
david	11680	0.3%
lucas	9957	0.3%
thomas	8444	0.3%
kevin	7908	0.2%
daniel	7764	0.2%
andré	7245	0.2%
pedro	7121	0.2%
joão	7084	0.2%
Other values (23832)	3280994	97.2%

Most occurring characters

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

competition_id
Categorical

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.0 MiB

IT1	139849
ES1	138147
GB1	135091
FR1	131229
TR1	119614
Other values (38)	1032310

Length

Max length	4
Median length	3
Mean length	2.932575
Min length	2

Characters and Unicode

Total characters	4974351
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CLQ
2nd row	ELQ
3rd row	ELQ
4th row	ELQ
5th row	ELQ

Common Values

Value	Count	Frequency (%)
IT1	139849	8.2%
ES1	138147	8.1%
GB1	135091	8.0%
FR1	131229	7.7%
TR1	119614	7.1%
L1	112441	6.6%
NL1	107748	6.4%
PO1	107305	6.3%
BE1	92929	5.5%
RU1	85204	5.0%
Other values (33)	526683	31.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
it1	139849	8.2%
es1	138147	8.1%
gb1	135091	8.0%
fr1	131229	7.7%
tr1	119614	7.1%
l1	112441	6.6%
nl1	107748	6.4%
po1	107305	6.3%
be1	92929	5.5%
ru1	85204	5.0%
Other values (33)	526683	31.1%

Most occurring characters

Value	Count	Frequency (%)
1	1451827	29.2%
R	532301	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183742	3.7%
P	176424	3.5%
Other values (10)	1006643	20.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4974351	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532301	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183742	3.7%
P	176424	3.5%
Other values (10)	1006643	20.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4974351	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532301	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183742	3.7%
P	176424	3.5%
Other values (10)	1006643	20.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4974351	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532301	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183742	3.7%
P	176424	3.5%
Other values (10)	1006643	20.2%

yellow_cards
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.8 MiB

0	1453054
1	236436
2	6750

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1696240
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1453054	85.7%
1	236436	13.9%
2	6750	0.4%

red_cards
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	93.8 MiB

0	1689826
1	6414

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1696240
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1696240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1689826	99.6%
1	6414	0.4%

goals
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.095945149

Minimum	0
Maximum	6
Zeros	1550722
Zeros (%)	91.4%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.33104245
Coefficient of variation (CV)	3.4503302
Kurtosis	17.871909
Mean	0.095945149
Median Absolute Deviation (MAD)	0
Skewness	3.8743458
Sum	162746
Variance	0.1095891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	1550722	91.4%
1	130219	7.7%
2	13566	0.8%
3	1562	0.1%
4	147	< 0.1%
5	23	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	1550722	91.4%
1	130219	7.7%
2	13566	0.8%
3	1562	0.1%
4	147	< 0.1%
5	23	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	23	< 0.1%
4	147	< 0.1%
3	1562	0.1%
2	13566	0.8%
1	130219	7.7%
0	1550722	91.4%

assists
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.075449818

Minimum	0
Maximum	6
Zeros	1577536
Zeros (%)	93.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.28542358
Coefficient of variation (CV)	3.7829591
Kurtosis	18.381635
Mean	0.075449818
Median Absolute Deviation (MAD)	0
Skewness	4.0511378
Sum	127981
Variance	0.081466619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	1577536	93.0%
1	110036	6.5%
2	8100	0.5%
3	530	< 0.1%
4	36	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	1577536	93.0%
1	110036	6.5%
2	8100	0.5%
3	530	< 0.1%
4	36	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	1	< 0.1%
4	36	< 0.1%
3	530	< 0.1%
2	8100	0.5%
1	110036	6.5%
0	1577536	93.0%

minutes_played
Real number (ℝ)

Distinct	122
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.08907

Minimum	1
Maximum	148
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	45
median	90
Q3	90
95-th percentile	90
Maximum	148
Range	147
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.981579
Coefficient of variation (CV)	0.43395546
Kurtosis	-0.38137054
Mean	69.08907
Median Absolute Deviation (MAD)	0
Skewness	-1.0701779
Sum	1.1719164 × 10⁸
Variance	898.89508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	907180	53.5%
45	66235	3.9%
1	26371	1.6%
78	11748	0.7%
12	11618	0.7%
76	11593	0.7%
77	11549	0.7%
14	11507	0.7%
75	11498	0.7%
74	11495	0.7%
Other values (112)	615446	36.3%

Value	Count	Frequency (%)
1	26371	1.6%
2	7796	0.5%
3	8545	0.5%
4	9092	0.5%
5	9663	0.6%
6	10271	0.6%
7	10756	0.6%
8	11084	0.7%
9	11253	0.7%
10	11241	0.7%

Value	Count	Frequency (%)
148	1	< 0.1%
135	2	< 0.1%
120	8143	0.5%
119	30	< 0.1%
118	30	< 0.1%
117	25	< 0.1%
116	21	< 0.1%
115	43	< 0.1%
114	28	< 0.1%
113	41	< 0.1%

	assists	competition_id	game_id	goals	minutes_played	player_club_id	player_current_club_id	player_id	red_cards	yellow_cards
assists	1.000	0.016	-0.010	0.072	0.055	-0.035	-0.035	-0.009	0.007	0.005
competition_id	0.016	1.000	0.114	0.016	0.088	0.166	0.193	0.069	0.016	0.045
game_id	-0.010	0.114	1.000	-0.006	-0.111	0.028	-0.043	0.640	0.007	0.016
goals	0.072	0.016	-0.006	1.000	0.050	-0.031	-0.036	-0.006	0.009	0.006
minutes_played	0.055	0.088	-0.111	0.050	1.000	-0.003	-0.024	-0.162	0.062	0.098
player_club_id	-0.035	0.166	0.028	-0.031	-0.003	1.000	0.618	0.080	0.002	0.008
player_current_club_id	-0.035	0.193	-0.043	-0.036	-0.024	0.618	1.000	0.001	0.001	0.007
player_id	-0.009	0.069	0.640	-0.006	-0.162	0.080	0.001	1.000	0.003	0.013
red_cards	0.007	0.016	0.007	0.009	0.062	0.002	0.001	0.003	1.000	0.012
yellow_cards	0.005	0.045	0.016	0.006	0.098	0.008	0.007	0.013	0.012	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	appearance_id	game_id	player_id	player_club_id	player_current_club_id	date	player_name	competition_id	yellow_cards	goals	assists	minutes_played
0	2231978_38004	2231978	38004	853	235	2012-07-03	Aurélien Joachim	CLQ	0	2	0	90
1	2233748_79232	2233748	79232	8841	2698	2012-07-05	Ruslan Abyshov	ELQ	0	0	0	90
2	2234413_42792	2234413	42792	6251	465	2012-07-05	Sander Puri	ELQ	0	0	0	45
3	2234418_73333	2234418	73333	1274	6646	2012-07-05	Vegar Hedenstad	ELQ	0	0	0	90
4	2234421_122011	2234421	122011	195	3008	2012-07-05	Markus Henriksen	ELQ	0	0	1	90
5	2234421_146889	2234421	146889	195	2778	2012-07-05	Peter Ankersen	ELQ	1	0	0	90
6	2235539_28716	2235539	28716	282	7185	2012-07-05	Adi Adilovic	ELQ	0	0	0	90
7	2235539_69445	2235539	69445	282	19771	2012-07-05	Ivan Sesar	ELQ	1	0	1	90
8	2235545_19409	2235545	19409	317	200	2012-07-05	Willem Janssen	ELQ	0	0	0	45
9	2235545_30003	2235545	30003	317	317	2012-07-05	Wout Brama	ELQ	0	0	0	90

	appearance_id	game_id	player_id	player_club_id	player_current_club_id	date	player_name	competition_id	yellow_cards	goals	minutes_played
1696230	4556277_342151	4556277	342151	2578	2578	2025-03-10	Daniels Balodis	SFA	0	0	90
1696231	4556277_359199	4556277	359199	2578	2578	2025-03-10	Andy Fisher	SFA	0	0	90
1696232	4556277_430976	4556277	430976	2578	2578	2025-03-10	Jonathan Svedberg	SFA	0	0	69
1696233	4556277_503731	4556277	503731	2578	2578	2025-03-10	Stephen Duke-McKenna	SFA	1	0	45
1696234	4556277_700144	4556277	700144	2578	2578	2025-03-10	Makenzie Kirk	SFA	0	0	90
1696235	4556277_741267	4556277	741267	2578	2578	2025-03-10	Sam Curtis	SFA	0	0	90
1696236	4556277_796307	4556277	796307	2578	2578	2025-03-10	Zach Mitchell	SFA	0	0	90
1696237	4556277_80339	4556277	80339	2578	2578	2025-03-10	Graham Carey	SFA	0	1	21
1696238	4556277_909254	4556277	909254	1241	43	2025-03-10	Macaulay Tait	SFA	0	0	90
1696239	4556277_91854	4556277	91854	2578	2578	2025-03-10	Barry Douglas	SFA	0	0	90

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample